package com.shangqing.system.duststorminfomation.mapper;

import com.shangqing.system.droughtinformation.entity.City;
import com.shangqing.system.duststorminfomation.entity.DustStorm;
import com.shangqing.system.duststorminfomation.entity.DustStormGrade;
import com.shangqing.system.duststorminfomation.entity.DustStormWarning;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface DustStormMapper {
    @Select("select * from dust_storms_all_infomation")
    List<DustStorm> getAllInfo();

    @Select("select * from dust_storms_grade where id=#{id}")
    DustStormGrade getDuststormGrade(int id);

    @Select("select * from dust_storms_warning where id=#{id}")
    DustStormWarning getDuststormWarning(int id);

    /**
     * 获取地区
     */
    @Select("select * from sys_city where id=#{id}")
    City getAllCity(int id);
}
